load data
truncate                                       
into table CRST_PO_DISTRIBUTIONS_ALL
fields terminated by "	"                      
trailing nullcols 
( PO_DISTRIBUTION_ID         ,
  LAST_UPDATE_DATE             Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY              ,
  PO_HEADER_ID                 ,
  PO_LINE_ID                   ,
  LINE_LOCATION_ID             ,
  SET_OF_BOOKS_ID              ,
  CODE_COMBINATION_ID          ,
  QUANTITY_ORDERED             ,
  LAST_UPDATE_LOGIN            ,
  CREATION_DATE                Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                   ,
  PO_RELEASE_ID                ,
  QUANTITY_DELIVERED           ,
  QUANTITY_BILLED              ,
  QUANTITY_CANCELLED           ,
  REQ_HEADER_REFERENCE_NUM     ,
  REQ_LINE_REFERENCE_NUM       ,
  REQ_DISTRIBUTION_ID          ,
  DELIVER_TO_LOCATION_ID       ,
  DELIVER_TO_PERSON_ID         ,
  RATE_DATE                    Date "YYYYMMDD HH24:MI:SS",
  RATE                         ,
  AMOUNT_BILLED                ,
  ACCRUED_FLAG                 ,
  ENCUMBERED_FLAG              ,
  ENCUMBERED_AMOUNT            ,
  UNENCUMBERED_QUANTITY        ,
  UNENCUMBERED_AMOUNT          ,
  FAILED_FUNDS_LOOKUP_CODE     ,
  GL_ENCUMBERED_DATE           Date "YYYYMMDD HH24:MI:SS",
  GL_ENCUMBERED_PERIOD_NAME    ,
  GL_CANCELLED_DATE            Date "YYYYMMDD HH24:MI:SS",
  DESTINATION_TYPE_CODE        ,
  DESTINATION_ORGANIZATION_ID  ,
  DESTINATION_SUBINVENTORY     ,
  ATTRIBUTE_CATEGORY           ,
  ATTRIBUTE1                   ,
  ATTRIBUTE2                   ,
  ATTRIBUTE3                   ,
  ATTRIBUTE4                   ,
  ATTRIBUTE5                   ,
  ATTRIBUTE6                   ,
  ATTRIBUTE7                   ,
  ATTRIBUTE8                   ,
  ATTRIBUTE9                   ,
  ATTRIBUTE10                  ,
  ATTRIBUTE11                  ,
  ATTRIBUTE12                  ,
  ATTRIBUTE13                  ,
  ATTRIBUTE14                  ,
  ATTRIBUTE15                  ,
  WIP_ENTITY_ID                ,
  WIP_OPERATION_SEQ_NUM        ,
  WIP_RESOURCE_SEQ_NUM         ,
  WIP_REPETITIVE_SCHEDULE_ID   ,
  WIP_LINE_ID                  ,
  BOM_RESOURCE_ID              ,
  BUDGET_ACCOUNT_ID            ,
  ACCRUAL_ACCOUNT_ID           ,
  VARIANCE_ACCOUNT_ID          ,
  PREVENT_ENCUMBRANCE_FLAG     ,
  USSGL_TRANSACTION_CODE       ,
  GOVERNMENT_CONTEXT           ,
  DESTINATION_CONTEXT          ,
  DISTRIBUTION_NUM             ,
  SOURCE_DISTRIBUTION_ID       ,
  REQUEST_ID                   ,
  PROGRAM_APPLICATION_ID       ,
  PROGRAM_ID                   ,
  PROGRAM_UPDATE_DATE          Date "YYYYMMDD HH24:MI:SS",
  PROJECT_ID                   ,
  TASK_ID                      ,
  EXPENDITURE_TYPE             ,
  PROJECT_ACCOUNTING_CONTEXT   ,
  EXPENDITURE_ORGANIZATION_ID  ,
  GL_CLOSED_DATE               Date "YYYYMMDD HH24:MI:SS",
  ACCRUE_ON_RECEIPT_FLAG       ,
  EXPENDITURE_ITEM_DATE        Date "YYYYMMDD HH24:MI:SS",
  ORG_ID                       ,
  KANBAN_CARD_ID               ,
  AWARD_ID                     ,
  MRC_RATE_DATE                ,
  MRC_RATE                     ,
  MRC_ENCUMBERED_AMOUNT        ,
  MRC_UNENCUMBERED_AMOUNT      ,
  END_ITEM_UNIT_NUMBER         ,
  TAX_RECOVERY_OVERRIDE_FLAG   ,
  RECOVERABLE_TAX              ,
  NONRECOVERABLE_TAX           ,
  RECOVERY_RATE                ,
  OKE_CONTRACT_LINE_ID         ,
  OKE_CONTRACT_DELIVERABLE_ID  
)
